Method and system for dynamically optimizing client queries to read-mostly servers

ABSTRACT

A system and method of query optimization are disclosed. A complexity measure of a client query received from a client application is compared to a predetermined threshold, which is determined using at least one of system data and query execution data. An optimized query is generated by modifying the client query to reduce the complexity measure of the client query if the complexity measure of the client query exceeds the predetermined threshold. The optimized query is submitted to a server application on a server and a post-processing routine to be applied to the result set is selected.

TECHNICAL FIELD

The present disclosure relates generally to query optimization, and moreparticularly to dynamic optimization of client queries to servers whosedata change slowly.

BACKGROUND

As the value and use of information continues to increase, individualsand businesses seek additional ways to process and store information.One option available to users is information handling systems. Aninformation handling system generally processes, compiles, stores,and/or communicates information or data for business, personal, or otherpurposes thereby allowing users to take advantage of the value of theinformation. Because technology and information handling needs andrequirements vary between different users or applications, informationhandling systems may also vary regarding what information is handled,how the information is handled, how much information is processed,stored, or communicated, and how quickly and efficiently the informationmay be processed, stored, or communicated. The variations in informationhandling systems allow for information handling systems to be general orconfigured for a specific user or specific use such as financialtransaction processing, airline reservations, enterprise data storage,or global communications. In addition, information handling systems mayinclude a variety of hardware and software components that may beconfigured to process, store, and communicate information and mayinclude one or more computer systems, data storage systems, andnetworking systems.

Query performance affects a user's ability to search and accessinformation that is stored in information handling systems. This isespecially true with respect to applications that use read-mostlyservers. Read-mostly servers contain data that change at a slow rate,which implies that queries usually return the same results each timethey run. For example, servers that support the Lightweight DirectoryAccess Protocol (LDAP) are often read-mostly because directoryinformation is relatively stable. Similarly, servers that support theMachine Readable Cataloging (MARC 21) bibliographic standard, as well asservers that hold historical information in general, tend to beread-mostly.

Response time at the client is an important performance measure ofclient/server systems. Response time is a function of client processingtime, server processing time, and network transmission time. Atraditional approach to improving response time is to increase client,server, or network capacity. This approach, however, is not alwaysfeasible given budget constraints. Another approach is to reconfigurethe server to better handle the type and number of queries that areexpected. Server tuning approaches like this can alleviate performanceproblems some of the time, but they cannot always adapt to changingworkloads in the information handling system (i.e., changes in overallserver load or changes in network load).

Moreover, server tuning may not be effective in mixed workloadenvironments that change over time. In particular, there may be no wayto optimize for both selective and unselective queries over the samedata. A selective query is one in which the server performs all thefiltering necessary to produce the precise result set specified by thequery. An unselective query, on the other hand, avoids some serveroverhead by returning a superset of the required result set at thepossible risk of incurring greater network and client overhead. It isthen up to the client to complete result set filtering. The conditionsthat favor one style of a query over another can change dynamically and,therefore, are not amenable to static solutions.

SUMMARY

In one embodiment of the present disclosure, a method of queryoptimization, is presented. The method includes comparing a complexitymeasure of a client query received from a client application to apredetermined threshold, wherein the predetermined threshold isdetermined using at least one of system data and query execution data.The method also includes generating an optimized query by modifying theclient query to reduce the complexity measure of the client query if thecomplexity measure of the client query exceeds the predeterminedthreshold. Additionally, the method includes submitting the optimizedquery to a server application on a server and selecting apost-processing routine to be applied to the result set.

In another embodiment of the present disclosure, a system includes aprocessor and a computer readable medium communicatively coupled to theprocessor. The computer readable medium includes computer-executableinstructions encoded in the computer readable medium, that, whenexecuted by the processor, are operable to compare a complexity measureof a client query received from a client application to a predeterminedthreshold, wherein the predetermined threshold is determined using atleast one of system data and query execution data. Thecomputer-executable instructions are further operable to, when executedby the processor, generate an optimized query by modifying the clientquery to reduce the complexity measure of the client query if thecomplexity measure of the client query exceeds the predeterminedthreshold. Additionally, the computer-executable instructions arefurther to, when executed by the processor, submit the optimized queryto a server application on a server and select a post-processing routineto be applied to the result set.

In still another embodiment of the present disclosure, a non-transitory,computer readable medium includes computer-executable instructionsencoded in the computer readable medium, that, when executed by theprocessor, are operable to compare a complexity measure of a clientquery received from a client application to a predetermined threshold,wherein the predetermined threshold is determined using at least one ofsystem data and query execution data. The computer-executableinstructions are further operable to, when executed by the processor,generate an optimized query by modifying the client query to reduce thecomplexity measure of the client query if the complexity measure of theclient query exceeds the predetermined threshold. Additionally, thecomputer-executable instructions are further to, when executed by theprocessor, submit the optimized query to a server application on aserver and select a post-processing routine to be applied to the resultset.

BRIEF DESCRIPTION OF THE DRAWINGS

A more complete understanding of the disclosed embodiments andadvantages thereof may be acquired by referring to the followingdescription taken in conjunction with the accompanying drawings, inwhich like reference numbers indicate like features, and wherein:

FIG. 1 illustrates a block diagram of an example system for dynamicallyoptimizing client queries to a server in accordance with the presentdisclosure.

FIG. 2 illustrates a block diagram of another example system fordynamically optimizing client queries to a server in accordance with thepresent disclosure.

FIG. 3 illustrates a block diagram of a further example system fordynamically optimizing client queries to a server in accordance with thepresent disclosure.

FIG. 4 illustrates a flow chart of an example method for dynamicallyoptimizing client queries to a server in accordance with the presentdisclosure.

DETAILED DESCRIPTION

Preferred embodiments and their advantages are best understood byreference to FIGS. 1-4, wherein like numbers are used to indicate likeand corresponding parts.

For the purposes of this disclosure, an information handling system mayinclude any instrumentality or aggregate of instrumentalities operableto compute, calculate, determine, classify, process, transmit, receive,retrieve, originate, switch, store, display, communicate, manifest,detect, record, reproduce, handle, or utilize any form of information,intelligence, or data for business, scientific, control, or otherpurposes. For example, an information handling system may be a personalcomputer (e.g., desktop or laptop), tablet computer, mobile device(e.g., personal digital assistant (PDA) or smart phone), server (e.g.,blade server or rack server), a network storage device, or any othersuitable device and may vary in size, shape, performance, functionality,and price. The information handling system may include random accessmemory (RAM), one or more processing resources such as a centralprocessing unit (CPU) or hardware or software control logic, ROM, and/orother types of nonvolatile memory. Additional components or theinformation handling system may include one or more disk drives, one ormore network ports for communicating with external devices as well asvarious input and output (I/O) devices, such as a keyboard, a mouse,touchscreen and/or a video display. The information handling system mayalso include one or more buses operable to transmit communicationbetween the various hardware components.

For the purposes of this disclosure, computer-readable media may includeany instrumentality or aggregation of instrumentalities that may retaindata and/or instructions for a period of time. Computer-readable mediamay include, without limitation, storage media such as a direct accessstorage device (e.g., a hard disk drive or floppy disk), a sequentialaccess storage device (e.g., a tape disk drive), compact disk, CD-ROM,DVD, random access memory (RAM), read-only memory (ROM), electricallyerasable programmable read-only memory (EEPROM), and/or flash memory; aswell as communications media such as wires, optical fibers, microwaves,radio waves, and other electromagnetic and/or optical carriers; and/orany combination of the foregoing.

The teachings of this disclosure may be used to improve queryperformance through query optimization. In some embodiments, queryoptimization may include reducing the time it takes for the clientapplication to receive the desired result set in order to improve queryperformance.

FIG. 1 illustrates a block diagram of an example system 100 fordynamically optimizing client queries to servers in accordance with theteachings of the present disclosure. System 100 may represent anysuitable system having one or more information handling systems and/orinformation handling resources. In some embodiments, system 100 mayinclude a server 110, a client system 120, and an optimizer 130. Server110, client system 120, and optimizer 130 may be communicatively coupledvia network 140.

Network 140 may be a network and/or fabric configured to communicativelycouple server 110, client system 120, optimizer 130, and/or any elementassociated with system 100. Network 140 may be implemented as, or may bea part of, a storage area network (SAN), personal area network (PAN),local area network (LAN), a metropolitan area network (MAN), a wide areanetwork (WAN), a wireless local area network (WLAN), a virtual privatenetwork (VPN), an intranet, the Internet or any other appropriatearchitecture or system that facilitates the communication of signals,data and/or messages (generally referred to as data). Network 140 maytransmit data using any storage and/or communication protocol, includingwithout limitation, Fibre Channel, Frame Relay, Asynchronous TransferMode (ATM), Internet protocol (IP), other packet-based protocol, smallcomputer system interface (SCSI), Internet SCSI (iSCSI), advancedtechnology attachment (ATA), serial ATA (SATA), advanced technologyattachment packet interface (ATAPI), serial storage architecture (SSA),integrated drive electronics (IDE), and/or any combination thereof.Network 140 and its various components may be implemented usinghardware, software, or any combination thereof.

Server 110 may be, for example, a read-mostly server. Server 110 mayinclude a processor (not expressly shown), server application 150, andinformation storage 160. The processor may include any system, device,or apparatus operable to interpret and/or execute program instructionsand/or process data, and may include without limitation amicroprocessor, microcontroller, digital signal processor (DSP),application specific integrated circuit (ASIC), or any other digital oranalog circuitry configured to interpret and/or execute programinstructions and/or process data. In some embodiments, the processor mayinterpret and/or execute program instructions and/or process data storedin information storage 160 and/or another component of server 110.

Server application 150 may be any application configured to implement aprotocol or standard in which the retrieval of read-mostly data involvesselection or filtering. For example, server application 150 may beconfigured to implement the Lightweight Directory Access Protocol(LDAP), the Digital Imaging and Communications Medicine (DICOM) standardor the Machine Readable Cataloging (MARC 21) standard.

Information storage 160 may include a database, directory, or other datastructure operable to store data. Further, information storage 160 mayinclude any instrumentality or aggregation of instrumentalities that mayretain data and/or instructions for a period of time. Informationstorage 160 may include random access memory (RAM), electricallyerasable programmable read-only memory (EEPROM), a Personal ComputerMemory Card International Association (PCMCIA) card, flash memory, solidstate disks, hard disk drives, magnetic tape libraries, optical diskdrives, magneto-optical disk drives, compact disk drives, compact diskarrays, disk array controllers, and/or any suitable selection or arrayof volatile or non-volatile memory operable to store data.

Client system 120 may be, for example, a personal computer, terminal, ornetwork computer. System 100 may include additional or fewer clientsystems, as desired. Client system 120 may include a processor (notexpressly shown), a memory (not expressly shown), and a clientapplication 170, which may include any application for interacting witha read-mostly server. The processor may include any system, device, orapparatus operable to interpret and/or execute program instructionsand/or process data, and may include without limitation amicroprocessor, microcontroller, digital signal processor (DSP),application specific integrated circuit (ASIC), or any other digital oranalog circuitry configured to interpret and/or execute programinstructions and/or process data. In some embodiments, the processor mayinterpret and/or execute program instructions and/or process data storedin the memory and/or another component of client system 120.

The memory may include any instrumentality or aggregation ofinstrumentalities that may retain data and/or instructions for a periodof time. Computer-readable media may include, without limitation,storage media such as a direct access storage device (e.g., a hard diskdrive or floppy disk), a sequential access storage device (e.g., a tapedisk drive), compact disk, CD-ROM, DVD, random access memory (RAM),read-only memory (ROM), electrically erasable programmable read-onlymemory (EEPROM), and/or flash memory; as well as communications mediasuch wires, optical fibers, microwaves, radio waves, and otherelectromagnetic and/or optical carriers; and/or any combination of theforegoing. Further, the memory may include a database containing querymodification strategies (e.g., ways in which queries may be modified togenerate an optimized query) and their corresponding post-processinginstructions.

Client application 170 may be a directory look-up application, whichqueries server application 150 for desired directory entries. Althoughclient application 170 may follow best practices when constructingqueries, the queries may not yield optimal performance because they donot account for the dynamic behavior of system 100. For example, clientapplication 170 may not be configured to account for changes in thehardware and/or software of server 110, changes in the amount ororganization of data stored on server 110, or changes to theconfiguration of the network 140. Additionally, client application 170may not be configured to evaluate or compensate for changes in the loadon server 110 or client system 120 (e.g., the amount of computationalwork that the server 110 or the client 120 performs), or load on network140 (e.g., the volume of network traffic).

Optimizer 130 may be configured to optimize queries constructed byclient application 170 to improve query response time (e.g., the time ittakes to receive the desired result set from the server application).Optimizer 130 may include a processor 180 and a storage device 190.Processor 180 may include any system, device, or apparatus operable tointerpret and/or execute program instructions and/or process data, andmay include without limitation a microprocessor, microcontroller,digital signal processor (DSP), application specific integrated circuit(ASIC), or any other digital or analog circuitry configured to interpretand/or execute program instructions and/or process data. In someembodiments, the processor may interpret and/or execute programinstructions and/or process data stored in storage device 190 and/oranother component of optimizer 130.

Storage device 190 may be communicatively coupled to processor 180 andmay include any system, device, or apparatus operable to retain programinstructions or data for a period of time (e.g., computer-readablemedia). Storage device 190 may include random access memory (RAM),electrically erasable programmable read-only memory (EEPROM), a PCMCIAcard, flash memory, solid state disks, hard disk drives, magnetic tapelibraries, optical disk drives, magneto-optical disk drives, compactdisk drives, compact disk arrays, disk array controllers, and/or anysuitable selection or array of volatile or non-volatile memory thatretains data after power to optimizer 130 is turned off. Further,storage device 190 may include a database containing query modificationstrategies (e.g., ways in which queries may be modified to generate anoptimized query) and their corresponding post-processing instructions.In some embodiments, optimizer 130 may be configured to improve queryperformance by dynamically rebalancing the load between server 110 andclient system 120. For example, a client query may be constructed suchthat data filtering is performed by (1) server 110 (e.g., a selectivequery), (2) client machine 120 (e.g., an unselective query), or (3) somecombination of server 110, client system 120, and optimizer 130. Theload between server 110 and client system 120 may be balanced bymodifying the client query to change where the filtering is performed.Thus, if the load on server 110 is high, a client query may be modifiedsuch that more of the filtering is performed by client system 120 and/oroptimizer 130. Similarly, if the load on client system 120 is high, aclient query may be modified such that more of the filtering isperformed by server 110 and/or optimizer 130.

In one embodiment, optimizer 130 may be configured to intercept a clientquery before it is submitted to server application 150. Optimizer 130may be further configured to determine whether and how a client queryshould be modified by comparing a complexity measure of the client queryto a predetermined threshold. The complexity measure of a particularclient query may be calculated using the number of operators, the typeof operator, and/or the number of sub-queries in the client query. Forexample, a client query requesting all entries where a person's lastname is Jackson, Jenkins, Johnson, Johnston, Jones, Johanssen, or Jordanmay be written as:(|(lastname=Jackson)(lastname=Jenkins)(lastname=Johnson)(lastname=Johnston)(lastname=Jones)(lastname=Johanssen)(lastname=Jordan).The complexity measure of such a query may be calculated by counting thenumber of “or” operators, in this case six.

As another example, a particular client query may request all entrieswhere a person's last name is Smith and the person lives in Dallas,Tex., and all entries where a person's last name is Jones and the personlives in Austin, Tex. For example, a client query of this type may bewritten as: (&(&(lastname=Smith)(city=Dallas,Texas))(&(lastname=Jones)(city=Austin, Texas))). The complexity measureof such a query may be calculated by counting the number of operatorsand/or the number of subqueries. In this example, there are three “and”operators and two subqueries. If the complexity measure of a clientquery exceeds the predetermined threshold, optimizer 130 may modify thequery to generate an optimized query with a complexity measure that isless than the predetermined threshold.

The predetermined threshold may be selected by identifying a thresholdquery complexity measure that corresponds to a maximum acceptable queryresponse time. The predetermined threshold may be determined by a useror may be dynamically determined by system 100 based on system dataand/or query execution data. System data may include static system dataand/or dynamic system data. Static system data may include informationrelated to server performance characteristics; server contentdistribution; and a predetermined maximum load on server 110, clientsystem 120, and/or network 140. Default values for static system datamay be provided to the optimizer 130 upon installation or the optimizermay request such data from the components of system 100. Static systemdata may also be obtained or modified via user input.

Dynamic system data may include information related to a measure of theload on server 110, client system 120, and/or network 140 at or near thetime the query is submitted. Optimizer 130 may obtain informationrelated to the current load on server 110 by requesting such informationfrom server 110. Similarly, optimizer 130 may obtain information relatedto the current load on client system 120 by requesting such informationfrom client system 120. To obtain information related to the currentload on network 140, the optimizer may submit requests to a router ofnetwork 140 or to a network interface of server 110 or client system120.

Query execution data may include, for a particular query, informationregarding the result set size; response times; execution times; load onserver 110, client system 120, and/or network 140 at the time the queryis submitted; and the query complexity measure. Query execution data maybe collected by optimizer 130 for each query submitted to serverapplication 150. Query execution data may be stored on the storagedevice 190. The types of queries that may be submitted to serverapplication 150 may include client queries, optimized queries, and/orprobe queries. Client queries may include queries constructed by clientapplication 170 and submitted to server application 150 withoutmodification. Optimized queries may include queries that have beenmodified by optimizer 130 prior to submission to sever application 150.Probe queries may be user configured queries or frequently used queries,and may be submitted to server application 150 for the purpose ofcollecting query execution data. Probe queries may be automaticallysubmitted to server application 150 at predetermined times and/orintervals set by a user.

The complexity measure of a query may be reduced, and thus the queryresponse time improved, by modifying the query such that the filteringis performed by client system 120 instead of server 110. For example,the query response time for a selective query (e.g., a query whereserver 110 performs the filtering) may exceed a maximum acceptable queryresponse time when the result set size is expected to be greater than4,000 entries. In these circumstances, a predetermined threshold couldbe selected such that queries with a result set size greater than 4,000are modified by converting the query from a selective query to anunselective query, thereby transferring the filtering operation fromserver 110 to client system 120 or optimizer 130.

As another example, the query execution data collected by optimizer 130may demonstrate that between 10:00 a.m. and 3:00 p.m. the query responsetimes for server 110 exceed a maximum acceptable query response timewhen the result set size is expected to exceed 3,000 entries. The queryexecution data may further demonstrate that during all other times, thequery response times for server 110 exceed a maximum acceptable queryresponse time when the result set size is expected to exceed 5,000entries. In these circumstances, a predetermined threshold may beselected such that a client query is modified from a selective query toan unselective query if (1) between 10:00 am and 3:00 pm, the result setsize is expected to exceed 3,000 entries; or (2) the result set size isexpected to be greater than 5,0000 entries. By modifying the clientquery in this way, the filtering is transferred from server 110 toclient system 120 or optimizer 130.

As an alternative to modifying a client query by converting it from aselective query to an unselective query or vice versa, a client querymay be modified by changing the database to which the query issubmitted. As an example, information storage 160 may include aplurality of replica databases to which client application 170 iscommunicatively coupled. Client application 170 may be configured toaccess each of the replica databases in a predetermined order. At anygiven time, however, one or more of the replica databases may provide ashorter response time than the replica databases that would ordinarilybe accessed first by client application 170. Based on the queryexecution data, optimizer 130 may modify the client query such that itis submitted to a replica database with a shorter response time.

If optimizer 130 modifies a client query to generate an optimized query,the optimizer may then submit the optimized query to server application150. Server application 150 may process the query and generate a resultset. In some embodiments, the result set may be sent to clientapplication 170 by server application 150. In other embodiments, serverapplication 150 may send the result to optimizer 130, which may thenforward the result set to client application 170.

Where optimizer 130 has generated and submitted an optimized query, itmay also generate and/or forward post-processing instructions to clientapplication 170. If a client query has been modified by optimizer 130,the result set returned from server application 150 may not match theresult set expected by client application 170. As a result, clientapplication 170 may be provided with instructions regarding thepost-processing to be performed on the result set. For example, if theoptimizer modifies a client query by converting it from a selectivequery to an unselective query, client application 170 may be providedwith instructions for filtering the result set.

In another embodiment, optimizer 130 may itself perform post-processingon the data returned from server application 150. In this case, theresult set returned to client application 170 is exactly the same as itwould have been had optimization not occurred.

Post-processing instructions may be generated individually by optimizer130 or may be pulled from a database containing query modificationstrategies and their corresponding post-processing instructions. Asstated above, such a database may be stored on storage device 190.

FIG. 2 illustrates another embodiment of the system illustrated in FIG.1, in which the optimizer may be included in the client system. As shownin FIG. 2, system 200 may include server 110 and a client system 220,which may be communicatively coupled via network 140. As discussedabove, server 110 may include server application 150 and informationstorage 160.

Client system 220 may be, for example, a personal computer, terminal, ornetwork computer. System 200 may include additional or fewer clientsystems, as desired. Client system 220 may include a processor (notexpressly shown), a memory (not expressly shown), a client application170, and an optimizer 230. The processor may include any system, device,or apparatus operable to interpret and/or execute program instructionsand/or process data, and may include without limitation amicroprocessor, microcontroller, digital signal processor (DSP),application specific integrated circuit (ASIC), or any other digital oranalog circuitry configured to interpret and/or execute programinstructions and/or process data. In some embodiments, the processor mayinterpret and/or execute program instructions and/or process data storedin the memory and/or another component of client system 220.

The memory may include any instrumentality or aggregation ofinstrumentalities that may retain data and/or instructions for a periodof time. Computer-readable media may include, without limitation,storage media such as a direct access storage device (e.g., a hard diskdrive or floppy disk), a sequential access storage device (e.g., a tapedisk drive), compact disk, CD-ROM, DVD, random access memory (RAM),read-only memory (ROM), electrically erasable programmable read-onlymemory (EEPROM), and/or flash memory; as well as communications mediasuch wires, optical fibers, microwaves, radio waves, and otherelectromagnetic and/or optical carriers; and/or any combination of theforegoing. Further, the memory may include a database containing querymodification strategies (e.g., ways in which queries may be modified togenerate an optimized query) and their corresponding post-processinginstructions.

As discussed above in conjunction with FIG. 1, client application 170may include any application operable to interact with a read-mostlyserver. For example, client application 170 may be a directoryapplication, which queries the server application 150 for desireddirectory entries.

Optimizer 230 may include hardware, software, or any combination thereofconfigured to modify queries constructed by client application 170 toimprove query response time (e.g., the time it takes to receive thedesired result set from the server application). As discussed above inconjunction with FIG. 1, optimizer 230 may intercept a client querybefore it is submitted to server application 150 and compare acomplexity measure of the client query to the predetermined threshold.If the complexity measure of the client query exceeds the predeterminedthreshold, optimizer 230 may modify the query to generate an optimizedquery with a complexity measure that is less than the predeterminedthreshold. If optimizer 230 modifies a client query to generate anoptimized query, the optimizer may submit the optimized query to serverapplication 150, which may process the query and generate a result set.Additionally, the optimizer 230 may generate and/or forwardpost-processing instructions to client application 170 or optimizer 230may perform the post-processing itself.

FIG. 3 illustrates a further embodiment of the system illustrated inFIG. 1, in which the optimizer may be included in the server. As shownin FIG. 3, system 300 may include server 310 and client system 120,which may be communicatively coupled via network 140. Server 310 may be,for example, a read-mostly server. Server 310 may include a processor(not expressly shown), server application 150, information storage 160,and optimizer 330. The processor may include any system, device, orapparatus operable to interpret and/or execute program instructionsand/or process data, and may include without limitation amicroprocessor, microcontroller, digital signal processor (DSP),application specific integrated circuit (ASIC), or any other digital oranalog circuitry configured to interpret and/or execute programinstructions and/or process data. In some embodiments, the processor mayinterpret and/or execute program instructions and/or process data storedin information storage 160 and/or another component of server 110.

Optimizer 330 may include hardware, software, or any combination thereofconfigured to modify queries constructed by client application 170 toimprove query response time (i.e., the time it takes to receive thedesired result set from the server application). In some embodiments,optimizer 330 and server application 150 may operate in a virtualenvironment where optimizer 330 is configured to run on a first virtualmachine and server application 150 is configured to run on a secondvirtual machine. In such a configuration, optimizer 330 and serverapplication 150 may be configured such that they do not compete for thesame resources.

As discussed above in conjunction with FIG. 1, optimizer 330 mayintercept a client query before it is submitted to server application150 and compare a complexity measure of the client query to apredetermined threshold. If the complexity measure of a client queryexceeds the predetermined threshold, optimizer 330 may modify the queryto generate an optimized query with a complexity measure that is lessthan the predetermined threshold. If optimizer 330 modifies a clientquery and generates an optimized query, the optimizer may then submitthe optimized query to server application 150, which may process thequery and generate a result set. Additionally, the optimizer 330 maygenerate and/or forward post-processing instructions to clientapplication 170 or optimizer 330 may perform the post-processing itself.

FIG. 4 illustrates an example method of dynamically optimizing clientqueries to a server in accordance with the teachings of the presentdisclosure. A complexity measure may be calculated for each client queryand compared to a predetermined threshold. If the complexity measure ofthe client query exceeds the predetermined threshold, the client querymay be modified to generate an optimized query, which may be submittedto a server application. The result set generated by the serverapplication from processing the optimized query may differ from theresult set that may have been generated if the client query weresubmitted without modification. As a result, the client application maybe provided with instructions regarding the filtering to be performed onthe result set.

If the complexity measure of the client query does not exceed thepredetermined threshold, the client query may be submitted to the serverapplication without modification. Query execution data may be collectedfor both optimized queries and client queries that may be submitted tothe server without modification.

At step 410, optimizer 130 may intercept a client query constructed by aclient application before it is submitted to a server application. Aclient query may be sent by the client application directly to theoptimizer or it may be sent to the server application and intercepted byoptimizer 130. At step 420, a complexity measure of a client query iscalculated. As discussed above in conjunction with FIG. 1, thecomplexity measure of a particular client query may be calculated byoptimizer 130 using any characteristic or combination of characteristicsof a query, including but not limited to the type of operators, numberof operators, and/or number of sub-queries in the client query. At step430, optimizer 130 may compare the complexity measure of the clientquery to a predetermined threshold. As discussed above in conjunctionwith FIG. 1, the predetermined threshold may be determined based systemdata and/or query execution data.

If the complexity measure of the client query does not exceed thepredetermined threshold, the method may proceed to step 435. At step435, the client query may be submitted to a server application 150without modification. At step 470, query execution data for thesubmitted query may be collected by optimizer 130. As discussed above inconjunction with FIG. 1, query execution data may include, for aparticular query, information regarding the result set size; responsetimes; execution times; load on the server, client system, and/ornetwork at the time the query is submitted; and the query complexitymeasure.

If, on the other hand, the complexity measure of the client queryexceeds the predetermined threshold, the method may proceed to step 440.At step 440, optimizer 130 may modify the client query to generate anoptimized query with a complexity measure that is less than thepredetermined threshold. At step 450, optimizer 130 may submit theoptimized query to server application 150. At step 460, optimizer 130may determine whether post-processing instructions are necessary. Asdiscussed above, a client query may be modified by converting the queryfrom a selective query to a less selective query; thus, the result setreturned from the server application may be unfiltered. Post-processingmay be needed by client application 170 to filter the result set. Ifsuch post-processing instructions are needed, optimizer 130 may generatethem. Optimizer 130 may then execute said post-processing instructionsor may forward the post-processing instructions to client application170 for execution.

At step 470, optimizer 130 may collect query execution data for theoptimized query. As discussed above in conjunction with FIG. 1, queryexecution data may include, for a particular query, informationregarding the result set size; response time; execution time; load onthe server, client system, and/or network at the time the query issubmitted; and the query complexity measure.

Method 400 may be implemented using the system of FIGS. 1-3, or anyother system operable to implement method 400. As such, the preferredinitialization point for method 400 and the order of the stepscomprising method 400 may depend on the implementation chosen. In someembodiments, some steps may be optionally omitted, repeated, orcombined. In some embodiments, portions of method 400 may be combined.In certain embodiments, method 400 may be implemented partially or fullyin software embodied in computer-readable media.

Although the present disclosure has been described in detail, it shouldbe understood that various changes, substitutions, and alterations canbe made hereto without departing from the spirit and the scope of thedisclosure as defined by the appended claims.

1.-20. (canceled)
 21. A method of query optimization, comprising:comparing a complexity measure of a client query received from a clientapplication to a predetermined threshold, wherein the predeterminedthreshold is determined based on query execution data collected from aprevious query; generating an optimized query by modifying the clientquery to reduce the complexity measure of the client query if thecomplexity measure of the client query exceeds the predeterminedthreshold; submitting the optimized query to a server application on aserver; and selecting a post-processing routine to be applied to aresult set of the optimized query.
 22. The method of claim 21, whereinthe complexity measure of the client query is calculated using at leastone of a type of operators in the client query, a number of operators inthe client query, and a number of sub-queries.
 23. The method of claim21, further comprising applying the post-processing routine to theresult set to generate a filtered result set.
 24. The method of claim21, wherein the predetermined threshold is determined further based onsystem data comprising at least one of: static system data including atleast one of server performance characteristics, server capacitycharacteristics, a server content distribution, a predetermined maximumclient load, a predetermined maximum server load, and predeterminedmaximum network load; and dynamic system data including at least one ofa measure of the server load at the time a query is submitted, a measureof the client load at the time the query is submitted, and a measure ofthe network load at the time the query is submitted.
 25. The method ofclaim 21, further comprising intercepting the client query from a clientapplication before the client query reaches a server application. 26.The method of claim 21, wherein the query execution data comprises, forat least one previously executed query, at least one of a result setsize, a query response time, a query execution time, a measure of thenetwork load at the time of query execution, and a query complexitymeasure.
 27. The method of claim 26, wherein the at least one previouslyexecuted query comprises at least one of a client query, an optimizedquery, or a probe query.
 28. The method of claim 27, further comprising:submitting the probe query to the server application, wherein the probequery is a user configured query or a frequently used query;automatically submitting the probe query to the server application at aselected time; and collecting query execution data for the probe query,wherein the query execution data for the probe query includes at leastone of a result set size, a query response time, a measure of thenetwork load at the time of query execution, and a query complexitymeasure.
 29. A system comprising: a processor; a computer readablemedium communicatively coupled to the processor; and computer-executableinstructions encoded in the computer readable medium, the instructions,when executed by the processor, operable to perform operationscomprising: comparing a complexity measure of a client query receivedfrom a client application to a predetermined threshold, wherein thepredetermined threshold is determined based on query execution datacollected from a previous query; generating an optimized query bymodifying the client query to reduce the complexity measure of theclient query if the complexity measure of the client query exceeds thepredetermined threshold; submitting the optimized query to a serverapplication on a server; and selecting a post-processing routine to beapplied to a result set of the optimized query.
 30. The system of claim29, wherein the complexity measure of the client query is calculatedusing at least one of a type of operators, a number of operators in theclient query or a number of sub-queries.
 31. The system of claim 29,wherein the instructions are further operable to perform operationscomprising applying the post-processing routine to the result set togenerate a filtered result set.
 32. The system of claim 29, wherein: thepredetermined threshold is determined further based on system datacomprising at least one of: static system data including at least one ofserver performance characteristics, server capacity characteristics, aserver content distribution, a predetermined maximum client load, apredetermined maximum server load, and predetermined maximum networkload; and dynamic system data including at least one of a measure of theserver load at the time a query is submitted, a measure of the clientload at the time the query is submitted, and a measure of the networkload at the time the query is submitted; and the query execution datacomprises, for at least one previously executed query, at least one of aresult set size, a query response time, a measure of the network load atthe time of query execution, and a query complexity measure.
 33. Thesystem of claim 32, wherein the at least one previously executed querycomprises at least one of a client query, an optimized query, or a probequery.
 34. The system of claim 33, wherein the instructions are furtheroperable to perform operations comprising: submitting the probe query tothe server application, wherein the probe query is a user configuredquery or a frequently used query; automatically submitting the probequery to the server application at a selected time; and collecting queryexecution data for the probe query, wherein the query execution data forthe probe query includes at least one of a result set size, a queryresponse time, a measure of the network load at the time of queryexecution, and a query complexity measure.
 35. A non-transitory,computer readable medium including computer-executable instructionsencoded in the computer readable medium, the instructions, when executedby the processor, operable to perform operations comprising: comparing acomplexity measure of a client query received from a client applicationto a predetermined threshold, wherein the predetermined threshold isdetermined based on query execution data collected from a previousquery; modifying the client query to generate an optimized query if thecomplexity measure of the client query exceeds the predeterminedthreshold; submitting the optimized query to a server application on aserver; and selecting a post-processing routine to be applied to aresult set of the optimized query.
 36. The non-transitory, computerreadable medium of claim 35, wherein the complexity measure of theclient query is calculated using at least one of a type of operators, anumber of operators in the client query or a number of sub-queries. 37.The non-transitory, computer readable medium of claim 35, thecomputer-executable instructions when executed by the processor, furtheroperable to perform operations comprising applying the post-processingroutine to the result set to generate a filtered result set.
 38. Thenon-transitory, computer readable medium of claim 35, wherein: thepredetermined threshold is determined further based on system datacomprising at least one of: static system data including at least one ofserver performance characteristics, server capacity characteristics, aserver content distribution, a predetermined maximum client load, apredetermined maximum server load, and predetermined maximum networkload; and dynamic system data including at least one of a measure of theserver load at the time a query is submitted, a measure of the clientload at the time the query is submitted, and a measure of the networkload at the time the query is submitted; and the query execution datacomprises, for a plurality of previously executed queries, at least oneof a result set size, a query response time, a measure of the networkload at the time of query execution, and a query complexity measure. 39.The non-transitory, computer readable medium of claim 38, wherein theplurality of previously executed queries comprises at least one of aclient query, an optimized query, or a probe query.
 40. Thenon-transitory, computer readable medium of claim 39, thecomputer-executable instructions when executed by the processor, furtheroperable to perform operations comprising: submitting the probe query tothe server application, wherein the probe query is a user configuredquery or a frequently used query; automatically submitting the probequery to the server application at a selected time; and collecting queryexecution data for the probe query, wherein the query execution data forthe probe query includes at least one of a result set size, a queryresponse time, a measure of the network load at the time of queryexecution, and a query complexity measure.